

------------------------------------------------------------------------------------------------
--Nombre: SP_Obtener
--Objetivo: Retorna un registro de la tabla ConfigAuditoriaTnda
--Creacion    : TISI(GOS) 20130226
------------------------------------------------------------------------------------------------

CREATE PROCEDURE SP_ObtenerConfigAuditoriaTnda
(
  @IDConfigAuditoria int,
  @CodConfigAudi varchar(15),
  @DescConfigAudi varchar(250),
  @PntjSIConfigAudi int,
  @PntjNOConfigAudi int,
  @PntjNAConfigAudi int,
  @EstadoConfigAuid int,
  @UsuReg varchar(20),
  @FecRegis datetime,
  @TermCnxReg varchar(50),
  @UsuMod varchar(20),
  @FecMod datetime,
  @TermCnxMod varchar(50),
  @IDEmp int)

AS
BEGIN
  SELECT
  IDConfigAuditoria,
    CodConfigAudi,
    DescConfigAudi,
    PntjSIConfigAudi,
    PntjNOConfigAudi,
    PntjNAConfigAudi,
    EstadoConfigAuid,
    UsuReg,
    FecRegis,
    TermCnxReg,
    UsuMod,
    FecMod,
    TermCnxMod,
    IDEmp
  FROM
  ConfigAuditoriaTnda
  WHERE   
  IDConfigAuditoria = @IDConfigAuditoria
END
GO

  